SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


create procedure dbo.DnnProduct_GetWorkflowStates
	@WorkflowID int

as

select *
from   dbo.DnnProduct_WorkflowStates
inner join dbo.DnnProduct_Workflow on dbo.DnnProduct_WorkflowStates.WorkflowID = dbo.DnnProduct_Workflow.WorkflowID
where dbo.DnnProduct_WorkflowStates.WorkflowID = @WorkflowID
order by [Order]

GO
